/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50717
 Source Host           : localhost:3306
 Source Schema         : test

 Target Server Type    : MySQL
 Target Server Version : 50717
 File Encoding         : 65001

 Date: 15/09/2020 01:52:39
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for hotjob
-- ----------------------------
DROP TABLE IF EXISTS `hotjob`;
CREATE TABLE `hotjob` (
  `id` bigint(20) NOT NULL COMMENT 'key',
  `jname` varchar(255) NOT NULL,
  `jdate` datetime NOT NULL,
  `salary` varchar(20) DEFAULT NULL,
  `degree` int(20) DEFAULT NULL,
  `experience` int(20) DEFAULT NULL,
  `inc` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of hotjob
-- ----------------------------
BEGIN;
INSERT INTO `hotjob` VALUES (1, '资深测试工程师', '2020-09-13 22:27:03', '30k-50k', 4, 3, '京东');
INSERT INTO `hotjob` VALUES (2, '高级技术美术', '2020-09-13 22:48:03', '25k-40k', 4, 4, '百度');
INSERT INTO `hotjob` VALUES (3, '品牌营销设计', '2020-09-14 22:27:03', '20k-30k', 4, 3, '美团');
INSERT INTO `hotjob` VALUES (4, 'C++开发工程师', '2020-09-13 20:27:03', '10k-20k', 4, 3, '阿里巴巴');
INSERT INTO `hotjob` VALUES (5, 'java开发工程师', '2020-09-13 11:27:03', '15k-30k', 4, 2, '腾讯');
INSERT INTO `hotjob` VALUES (6, 'java开发高级工程师', '2020-09-13 14:27:03', '25k-40k', 4, 3, '拼多多');
INSERT INTO `hotjob` VALUES (7, 'java架构师', '2020-09-13 16:27:03', '30k-50k', 4, 4, '字节跳动');
INSERT INTO `hotjob` VALUES (8, 'python开发工程师', '2020-09-13 15:27:03', '20k-30k', 4, 3, '网易');
INSERT INTO `hotjob` VALUES (9, 'golang开发工程师', '2020-09-14 02:27:03', '20k-30k', 4, 3, '知乎');
INSERT INTO `hotjob` VALUES (10, '前端开发工程师', '2020-09-13 15:27:03', '18k-25k', 4, 3, '华为');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
